package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "c_card_batch", simpleName = "", engine = MysqlDriver.InnoDB, comment = "批次信息")
public class _DDL_CCardBatch {

    @_DDL_Primary()
    @_DDL_Column(name = "batch_no", type = SqlType.VARCHAR, size = 32, nullable = false, comment = "id")
    private String batchNo;

    @_DDL_Column(name = "card_type", type = SqlType.VARCHAR, size = 3, comment = "卡前缀")
    private String cardType;

    @_DDL_Column(name = "ind_id", type = SqlType.VARCHAR, size = 4, comment = "行业id")
    private String indId;

    @_DDL_Column(name = "city_code", type = SqlType.CHAR, size = 4, comment = "城市代码")
    private String cityCode;

    @_DDL_Column(name = "app_version", type = SqlType.TINYINT_UNSIGNED, comment = "应用版本")
    private Integer appVersion;

    @_DDL_Column(name = "trans_id", type = SqlType.SMALLINT_UNSIGNED, comment = "互通id")
    private Integer transId;

    @_DDL_Column(name = "main_type", type = SqlType.TINYINT_UNSIGNED, comment = "卡主类型")
    private Integer mainType;

    @_DDL_Column(name = "sub_type", type = SqlType.TINYINT_UNSIGNED, comment = "卡子类型")
    private Integer subType;

    @_DDL_Column(name = "count", type = SqlType.SMALLINT_UNSIGNED, comment = "数量")
    private Integer count;

    @_DDL_Column(name = "open_count", type = SqlType.SMALLINT_UNSIGNED, comment = "开卡数量")
    private Integer openCount;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "绑定时间")
    private java.sql.Timestamp crTime;

}
